package com.milhouz.quizzdroid.db;

public class QuizzDroidConstants {

	public static final String TAG = "quizzdroid";

	public static final String CSV_QUESTIONS_FILE = "openquizzdb_fr.csv";

	// Quizz database
	public static final String DATABASE_NAME = "QUIZZDROID_DATABASE";
	public static final int DATABASE_VERSION = 1;
	public static final String TABLE_NAME_QUESTIONS = "QUIZ_QUESTIONS";
	public static final String TABLE_NAME_CATEGORIES = "CATEGORY_QUESTIONS";
	public static final String TABLE_NAME_RESPONSES = "POTENTIAL_RESPONSES";
	public static final String ID = "ID";
	public static final String COLUMN_NAME_QUESTION = "QUESTION";
	public static final String COLUMN_NAME_RESPONSE = "RESPONSE";
	public static final String COLUMN_NAME_RESPONSE_NUMBER = "RESPONSE_NUMBER";
	public static final String COLUMN_NAME_CATEGORY_ID = "CATEGORY_ID";
	public static final String COLUMN_NAME_LABEL = "LABEL";
	public static final String COLUMN_NAME_QUESTION_ID = "QUESTION_ID";
	public static final String COLUMN_NAME_IS_GOOD_RESPONSE = "IS_GOOD_RESPONSE";

	// User and statistiques database
	public static final String USER_DATABASE_NAME = "QUIZZDROID_USER_DATABASE";
	public static final int USER_DATABASE_VERSION = 1;
	public static final String TABLE_NAME_USERS = "QDP_USER";
	public static final String COLUMN_NAME_USERNAME = "USERNAME";
	public static final String COLUMN_NAME_TOTAL_QUESTIONS = "TOTAL_QUESTIONS";
	public static final String COLUMN_NAME_NB_GOOD_RESPONSES = "NB_GOOD_RESPONSES";
	public static final String COLUMN_NAME_MEANTIME = "MEANTIME";
	public static final Integer DEFAULT_USERID = 1;
	public static final String DEFAULT_USERNAME = "default";

	private QuizzDroidConstants() {

	}

}
